Insert Summary dialog box

This dialog box appears when you click Insert Summary on the Standard toolbar, or when you choose the Summary command from the Insert menu.

Use the Insert Summary dialog box to summarize the data in a field in your report.

Note:    

Summary types

This list contains all the summary operations available for use in your report. Select the desired operation.

Fields (to summarize)

This list displays the fields and formulas used in the report. Select the field that you want to summarize.

Fields (to sort and group by)

This list displays the fields and formulas used in the report. Select the field that you want to sort and group by.

Sort direction

This list contains four sort direction options. The default option is in ascending order. To change the sort direction, click the box to see the options, then make your selection from the list.

Show as a percentage of

Select this check box if you want to calculate the percentage total of one group within a broader grouping. For example, you can show the percentage of sales in each city based on the total sales for each country.

After you select the check box, you can choose the total or group you want the comparison to be based on.

Note:    The percentage option is available only when the result of a summary operation is numeric.

Keep group together

Select this check box to keep groups from being split across a page. This will force groups to stay together. If there is enough room to keep them on the current page, the program will print them on the current page. If there is not enough room, the program will print them on the next page.

Repeat group header on each new page

Select this check box if you want the program to print a new group header at the top of each page if a group is spread over several pages. Otherwise, a group header prints only at the beginning of the group.

Sum across hierarchy

This option enables you to calculate a summary across hierarchical groupings. To set or edit Hierarchical Options for existing groups, click Hierarchical Grouping Options on the Report menu. For details, see Grouping data hierarchically.

Related topics

Summary command

Using the Summary command



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com